CREATE TABLE [dbo].[bPricing]
(
[PricingId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PriceDate] [date] NOT NULL,
[Bid] [decimal] (18, 6) NULL,
[Offer] [decimal] (18, 6) NULL,
[Mid] [decimal] (18, 6) NULL,
[PricingSource] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [smalldatetime] NOT NULL,
[CreatedBy] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[ModifiedBy] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OpenPr] [decimal] (18, 6) NULL,
[High] [decimal] (18, 6) NULL,
[Low] [decimal] (18, 6) NULL,
[ClosePr] [decimal] (18, 6) NULL,
[Volume] [decimal] (18, 6) NULL,
[AdjClose] [decimal] (18, 6) NULL,
[Depth] [decimal] (18, 6) NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'MVA Stuff', 'SCHEMA', N'dbo', 'TABLE', N'bPricing', NULL, NULL
GO
